An enterprise PWA for a firm's compliance workflow. Connects directly to their Excel files — any data change triggers instant push notifications to all relevant users. Automated reminders keep teams accountable without a compliance officer manually chasing anyone down.
Compliance teams spend enormous time chasing people — "did you see the deadline?", "the Excel was updated". This system makes that chasing automatic. Any change to the connected Excel sheets triggers an immediate push notification to the relevant team member.
Overdue items escalate automatically. Deadline reminders fire at 7, 3, and 1 day out. When something is marked complete, the whole team gets notified. Nobody needs to check the spreadsheet — the spreadsheet comes to them.
The system polls the Excel files via Microsoft Graph API on a short interval. Each change is diffed against the previous state — only changed rows trigger notifications. A service worker manages push delivery to ensure notifications arrive even when the PWA is closed.
Diffing large Excel files efficiently on a short polling interval without hammering the Graph API or producing false-positive notifications on unrelated cell changes.
Ensuring push notifications arrive reliably even when the PWA is not open — requiring proper service worker registration and VAPID key management.
Different Excel rows belong to different users. The mapping between rows and responsible persons needed to be configurable without touching code.
Building a reliable reminder scheduler that fires at the right intervals without duplicate notifications, even across server restarts and timezone changes.